RowSource property

The RowSource property is used to specify data to be used in a list box, a combo box, or an unbound OLE object such as a chart. There are three types of row sources: Table/Query, Value List, and Field List.

For the Table/Query type, the valid RowSource property is the name of a table, query, or SQL statement. For the Value List type, the valid RowSource property is a list of items separated by semicolons. For the Field List type, the valid RowSource property is the name of the table, query, or SQL statement containing the desired field list.

When setting the RowSource property, make sure that the name of the table or query is correct; the items in the list are separated by semicolons; for the Value List type, the total number of items is a multiplier of the number of columns specified; and the SQL statement is entered correctly.